Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
WorkstationID (FK)(PK) | The unique identifier for the WORKSTATION, typically the serial number. | ID_WS | Identity | integer | Workstation(AS_WS) |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
TotalTenderLoanCount | The total number of tender loans made to the WORKSTATION for each REPORTING PERIOD. | QU_LON_TND_TOT | QuantityTransactionCount | decimal(7,0) | |
GrossPositiveTotalAmount | The total monetary positive gross sales amount recorded by WORKSTATION for each REPORTING PERIOD. | TP_SLS_GS_PSTV_TOT | Money | decimal(16,5) | |
GrossNegativeTotalAmount | The total monetary gross negative sales amount recorded by WORKSTATION for each REPORTING PERIOD. | TP_SLS_GS_NG_TOT | Money | decimal(16,5) | |
TotalTransactionCount | The total number of transactions by WORKSTATION for each REPORTING PERIOD. | QU_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |
LineItemVoidTotalAmount | The total monetary amount of line item voids made by WORKSTATION for each REPORTING PERIOD. | CP_VD_LN_ITM_TOT | Money | decimal(16,5) | |
TotalLineItemVoidCount | The total number of line item voids recorded by WORKSTATION for each REPORTING PERIOD. | QU_LTM_VD_TOT | QuantityTransactionCount | decimal(7,0) | |
PostTransactionVoidTotalAmount | The total monetary value of post-transaction voids by WORKSTATION for each REPORTING PERIOD. | CP_VD_PST_TRN_TOT | Money | decimal(16,5) | |
TotalPostTransactionVoidCount | The total number of the transaction voids by WORKSTATION for each REPORTING PERIOD. | QU_VD_PST_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |
TransactionVoidTotalAmount | The total monetary value of transaction voids by WORKSTATION for each REPORTING PERIOD. | CP_VD_TRN_TOT | Money | decimal(16,5) | |
TotalTransactionVoidCount | The total number of transaction voids by WORKSTATION for each REPORTING PERIOD. | QU_VD_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalTenderPickupCount | The total number amount of tender pickups from this WORKSTATION for each REPORTING PERIOD. | QU_PKP_TND_TOT | QuantityTransactionCount | decimal(7,0) | |
TenderPickupTotalAmount | The total monetary value of tender pickups by WORKSTATION for each REPORTING PERIOD. | CP_PKP_TND_TOT | Money | decimal(16,5) | |
TenderLoanTotalAmount | The total monetary value of tender pickups by WORKSTATION for each REPORTING PERIOD. | CP_LON_TND_TOT | Money | decimal(16,5) | |
ReturnTotalAmount | The total monetary amount of returns recorded by WORKSTATION for each REPORTING PERIOD. | CP_RTN_TOT | Money | decimal(16,5) | |
TotalReturnCount | The total number of returns recorded by WORKSTATION for each REPORTING PERIOD. | QU_RTN_TOT | QuantityTransactionCount | decimal(7,0) | |
RefundTotalAmount | The total monetary amount of refunds recorded by WORKSTATION for each REPORTING PERIOD. | CP_RFD_TOT | Money | decimal(16,5) | |
TotalRefundCount | The total number of refunds recorded by WORKSTATION for each REPORTING PERIOD. | QU_RFD_TOT | QuantityTransactionCount | decimal(7,0) | |
EmployeeDiscountTotalAmount | The total monetary amount of employee discounts by WORKSTATION for each REPORTING PERIOD. | CP_DS_EM_TOT | Money | decimal(16,5) | |
TotalEmployeeDiscountCount | The total number of employee item line discounts by WORKSTATION for each REPORTING PERIOD. | QU_DSC_EM_TOT | QuantityTransactionCount | decimal(7,0) | |
MiscellaneousDiscountTotalAmount | The total monetary amount of miscellaneous discounts by WORKSTATION for each REPORTING PERIOD. | CP_DSC_MSC_TOT | Money | decimal(16,5) | |
TotalMiscellaneousDiscountCount | The total number of miscellaneous line items by WORKSTATION for each REPORTING PERIOD. | QU_DSC_MSC_TOT | QuantityTransactionCount | decimal(7,0) | |
StoreCouponTotalAmount | The total monetary amount of store coupons accepted by WORKSTATION for each REPORTING PERIOD. | CP_CPN_STR_TOT | Money | decimal(16,5) | |
TotalStoreCouponCount | The total number of store coupons accepted by WORKSTATION for each REPORTING PERIOD. | QU_CPN_STR_TOT | QuantityTransactionCount | decimal(7,0) | |
RedeemedContainerDepositTotalAmount | The total monetary amount of container deposits redeemed by WORKSTATION for each REPORTING PERIOD. | CP_DS_RDM_CNR_TOT | Money | decimal(16,5) | |
TotalRedeemedContainerDepositCount | The total number of container deposits redeemed by WORKSTATION for each REPORTING PERIOD. | QU_DS_RDM_CNR | QuantityTransactionCount | decimal(7,0) | |
MarkdownTotalAmount | The total monetary amount of price markdowns made by WORKSTATION for each REPORTING PERIOD. | CP_MKD_TOT | Money | decimal(16,5) | |
TotalMarkdownCount | The total number of price markdowns made by WORKSTATION for each REPORTING PERIOD. | QU_MKD_TOT | QuantityTransactionCount | decimal(7,0) | |
NetSalesTotalAmount | The total monetary amount of net sales recorded by WORKSTATION for each REPORTING PERIOD. | TP_SLS_NT_TOT | Money | decimal(16,5) | |
MiscellaneousFeeTotalAmount | The total monetary amount of miscellaneous fees recorded by WORKSTATION for each REPORTING PERIOD. | CP_FE_MSC_TOT | Money | decimal(16,5) | |
TotalMiscellaneousFeeCount | The total number of miscellaneous fees recorded by WORKSTATION for each REPORTING PERIOD. | QU_FE_MSC_TOT | QuantityTransactionCount | decimal(7,0) | |
ContainerDepositTotalAmount | The total monetary amount of deposit container deposits collected by WORKSTATION for each REPORTING PERIOD. | MO_DS_CNR_TOT | Money | decimal(16,5) | |
TotalContainerDepositCount | The total number of deposit container deposits collected by WORKSTATION for each REPORTING PERIOD. | QU_DS_CNR_TOT | QuantityTransactionCount | decimal(7,0) | |
PaymentsCollectedTotalAmount | The total monetary amount of payments collected by WORKSTATION for each REPORTING PERIOD. | CP_PYM_CLT_TOT | Money | decimal(16,5) | |
TotalPaymentsCollectedCount | The total number of payments collected by WORKSTATION for each REPORTING PERIOD. | QU_PYM_CLT_TOT | QuantityTransactionCount | decimal(7,0) | |
LayawayPaymentsCollectedTotalAmount | The total monetary amount of layaway payments collected by WORKSTATION for each REPORTING PERIOD. | CP_PYM_LY_CLT_TOT | Money | decimal(16,5) | |
TotalLayawayPaymentsCollectedCount | The total number of layaway payments collected by WORKSTATION for each REPORTING PERIOD. | QU_PYM_LY_CLT_TOT | QuantityTransactionCount | decimal(7,0) | |
PettyCashDisbursementTotalAmount | The total monetary amount of petty cash payments disbursed by WORKSTATION for each REPORTING PERIOD. | CP_DSB_PTY_CSH_TOT | Money | decimal(16,5) | |
TotalPettyCashDisbursementLineItemCount | The total number of petty cash line item payments disbursed by WORKSTATION for each REPORTING PERIOD. | QU_DSB_PTY_LN_ITM | QuantityTransactionCount | decimal(7,0) | |
GrossSalesExTaxTotalAmount | The total gross sales excluding tax recorded by WORKSTATION for each REPORTING PERIOD. | TP_SLS_EX_TX_TOT | Money | decimal(16,5) | |
TaxTotalAmount | The total tax amount recorded by WORKSTATION for each REPORTING PERIOD. | CP_TX_TOT | Money | decimal(16,5) | |
TaxExemptTotalAmount | The total tax exempt amount recorded by WORKSTATION for each REPORTING PERIOD. | CP_TX_EXM_TOT | Money | decimal(16,5) | |
TotalTaxExemptTransactionCount | The total number of tax exempt transactions recorded by WORKSTATION for each REPORTING PERIOD. | QU_TRN_TX_EXM_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemOverrideCount | The total number of line item overrides recorded by WORKSTATION for each REPORTING PERIOD. | QU_LTM_SC_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalWeighedLineItemCount | The total number of weighed line items recorded by WORKSTATION for each REPORTING PERIOD. | QU_ITM_LN_WT_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemKeyedCount | The total number of ITEMs keyed at the point of sale by WORKSTATION for each REPORTING PERIOD. | QU_LTM_KY_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemScannedCount | The total number of ITEMs scanned by WORKSTATION for each REPORTING PERIOD. | QU_SC_LN_ITM_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemKeyedPercentage | The percentage of ITEMs keyed at the point of sale compared to the total sold ITEMs by WORKSTATION for each REPORTING PERIOD. | PE_LTM_KY_TOT | Percent | decimal(7,4) | |
TotalLineItemScannedPercentage | The percentage of ITEMs scanned compared to the total sold ITEMs by WORKSTATION for each REPORTING PERIOD. | PE_LTM_SC_TOT | Percent | decimal(7,4) | |
TotalLineItemOpenDepartmentCount | The number of ITEMs recorded through an open department by WORKSTATION for each REPORTING PERIOD. | QU_LTM_DPT_OPN | QuantityTransactionCount | decimal(7,0) | |
TotalLineItemOpenDepartmentPercentage | The percentage of ITEMs recorded through an open department compared to the total ITEMs by WORKSTATION for each REPORTING PERIOD. | PE_LTM_DPT_OPN | Percent | decimal(7,4) | |
TotalNoSaleTransactionCount | The total number of no sale transactions by WORKSTATION for each REPORTING PERIOD. | QU_TRN_NO_SLS_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalRingTime | The total time expressed in minutes spent scanning or keying line items into the WORKSTATION for each REPORTING PERIOD. | IN_RNG_TOT | QuantityShortCountSeconds | decimal(5,0) | |
TotalIdleTime | The total time expressed in minutes by WORKSTATION where no sales are being recorded for each REPORTING PERIOD. | IN_IDL_TOT_TOT | QuantityShortCountSeconds | decimal(5,0) | |
TotalLockTime | The total time expressed in minutes when the WORKSTATION is locked but the OPERATOR is logged onto the WORKSTATION for each REPORTING PERIOD. | IN_LCK_TOT | QuantityShortCountSeconds | decimal(5,0) | |
TotalSaleLineItemCount | The total number of line item sales by WORKSTATION for each REPORTING PERIOD. | QU_ITM_LN_SLS_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalSignOnCount | The total number of operator sign-ons on this WORKSTATION for each REPORTING PERIOD. | QU_SGN_ON_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalSignOffCount | The total number of operator sign-offs on this WORKSTATION for each REPORTING PERIOD. | QU_SGN_OFF_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalTenderOverAmount | The total monetary amount of tender overages by WORKSTATION for each REPORTING PERIOD. | CP_TND_OVR_TOT | Money | decimal(16,5) | |
TotalTenderUnderAmount | The total monetary amount of tender shortages by WORKSTATION for each REPORTING PERIOD. | CP_TND_UND_TOT | Money | decimal(16,5) | |
IntermediateTenderReconciliationCount | The total number of intermediate tender reconciliation counts by WORKSATION for each REPORTING PERIOD. | QU_RCN_INTM_TND | QuantityTransactionCount | decimal(7,0) | |
TotalSendCheckAmount | The total monetary amount of send checks recorded by WORKSTATION for each REPORTING PERIOD. | CP_CHK_SND_TOT | Money | decimal(16,5) | |
TotalSendCheckCount | The total number of send checks recorded by WORKSTATION for each REPORTING PERIOD. | QU_CHK_SND_TOT | QuantityTransactionCount | decimal(7,0) | |
SuspendedTotalAmount | The total monetary amount of suspended transactions by WORKSTATION for each REPORTING PERIOD. | CP_SLS_SPN_TOT | Money | decimal(16,5) | |
SuspendedTransactionCount | The total number of suspended transactions by WORKSTATION for each REPORTING PERIOD. | QU_TRN_SPN | QuantityTransactionCount | decimal(7,0) | |
ResumedTotalAmount | The total monetary amount of suspended transactions resumed by WORKSTATION for each REPORTING PERIOD. | CP_SLS_RSM_TOT | Money | decimal(16,5) | |
ResumedTransactionCount | The total number of suspended transactions resumed by WORKSTATION for each REPORTING PERIOD. | QU_TRN_RSM | QuantityTransactionCount | decimal(7,0) | |